clear all

#delimit ;
*  PSID DATA CENTER *****************************************************
   JOBID            : 318737                            
   DATA_DOMAIN      : IND                               
   USER_WHERE       : NULL                              
   FILE_TYPE        : All Individuals Data              
   OUTPUT_DATA_TYPE : ASCII                             
   STATEMENTS       : do                                
   CODEBOOK_TYPE    : PDF                               
   N_OF_VARIABLES   : 476                               
   N_OF_OBSERVATIONS: 82573                             
   MAX_REC_LENGTH   : 1027                              
   DATE & TIME      : April 6, 2023 @ 17:55:46
*************************************************************************
;

infix
      ER30000              1 - 1           ER30001              2 - 5           ER30002              6 - 8     
      V1                   9 - 9           V99                 10 - 10          V117                11 - 12    
      V118                13 - 14          ER30003             15 - 15          ER30004             16 - 18    
      V441                19 - 19          V553                20 - 20          V1008               21 - 22    
      V1011               23 - 24          ER30020             25 - 28          ER30021             29 - 30    
      ER30022             31 - 31          ER30023             32 - 34          V1101               35 - 35    
      V1236               36 - 36          V1239               37 - 38          V1241               39 - 40    
      ER30043             41 - 44          ER30044             45 - 46          ER30045             47 - 47    
      ER30046             48 - 50          V1801               51 - 51          V1939               52 - 52    
      V1942               53 - 54          V1944               55 - 56          ER30067             57 - 60    
      ER30068             61 - 62          ER30069             63 - 63          ER30070             64 - 66    
      V2401               67 - 67          V2539               68 - 68          V2542               69 - 70    
      V2544               71 - 72          ER30091             73 - 76          ER30092             77 - 78    
      ER30093             79 - 79          ER30094             80 - 82          V3001               83 - 83    
      V3092               84 - 84          V3095               85 - 86          V3097               87 - 88    
      ER30117             89 - 92          ER30118             93 - 94          ER30119             95 - 95    
      ER30120             96 - 98          V3401               99 - 99          V3505              100 - 100   
      V3508              101 - 102         V3510              103 - 104         ER30138            105 - 108   
      ER30139            109 - 110         ER30140            111 - 111         ER30141            112 - 114   
      V3801              115 - 115         V3918              116 - 116         V3921              117 - 118   
      V3923              119 - 120         ER30160            121 - 124         ER30161            125 - 126   
      ER30162            127 - 127         ER30163            128 - 130         V4301              131 - 131   
      V4433              132 - 132         V4436              133 - 134         V4438              135 - 136   
      V4741              137 - 137         ER30188            138 - 141         ER30189            142 - 143   
      ER30190            144 - 144         ER30191            145 - 147         V5201              148 - 148   
      V5347              149 - 149         V5350              150 - 151         V5352              152 - 153   
      ER30217            154 - 157         ER30218            158 - 159         ER30219            160 - 160   
      ER30220            161 - 163         V5701              164 - 164         V5847              165 - 165   
      V5850              166 - 167         V5852              168 - 169         ER30246            170 - 173   
      ER30247            174 - 175         ER30248            176 - 176         ER30249            177 - 179   
      V6301              180 - 180         V6459              181 - 181         V6462              182 - 183   
      V6464              184 - 185         ER30283            186 - 189         ER30284            190 - 191   
      ER30285            192 - 192         ER30286            193 - 195         V6901              196 - 196   
      V7064              197 - 200         V7067              201 - 202         V7069              203 - 204   
      ER30313            205 - 208         ER30314            209 - 210         ER30315            211 - 211   
      ER30316            212 - 214         V7501              215 - 215         V7655              216 - 219   
      V7658              220 - 221         V7660              222 - 223         ER30343            224 - 227   
      ER30344            228 - 229         ER30345            230 - 230         ER30346            231 - 233   
      V8201              234 - 234         V8349              235 - 238         V8352              239 - 240   
      V8354              241 - 242         ER30373            243 - 246         ER30374            247 - 248   
      ER30375            249 - 249         ER30376            250 - 252         V8801              253 - 253   
      V8958              254 - 257         V8961              258 - 259         V8963              260 - 261   
      V9408              262 - 262         ER30399            263 - 266         ER30400            267 - 268   
      ER30401            269 - 270         ER30402            271 - 273         ER30403            274 - 275   
      ER30404            276 - 279         V10001             280 - 280         V10416             281 - 284   
      V10419             285 - 286         V10421             287 - 288         V11055             289 - 289   
      ER30429            290 - 293         ER30430            294 - 295         ER30431            296 - 297   
      ER30432            298 - 300         ER30433            301 - 302         ER30434            303 - 306   
      V11101             307 - 307         V11600             308 - 311         V11603             312 - 315   
      V11606             316 - 317         V11608             318 - 319         V11938             320 - 320   
      V12293             321 - 321         ER30463            322 - 325         ER30464            326 - 327   
      ER30465            328 - 329         ER30466            330 - 332         ER30467            333 - 334   
      ER30468            335 - 338         V12501             339 - 339         V13008             340 - 343   
      V13011             344 - 345         V13013             346 - 347         V13500             348 - 348   
      V13565             349 - 349         ER30498            350 - 353         ER30499            354 - 355   
      ER30500            356 - 357         ER30501            358 - 360         ER30502            361 - 362   
      ER30503            363 - 366         V13701             367 - 367         V14111             368 - 371   
      V14114             372 - 373         V14116             374 - 375         V14547             376 - 376   
      V14612             377 - 377         ER30535            378 - 381         ER30536            382 - 383   
      ER30537            384 - 385         ER30538            386 - 388         ER30539            389 - 390   
      ER30540            391 - 394         V14801             395 - 395         V15127             396 - 399   
      V15130             400 - 401         V15132             402 - 403         V16021             404 - 404   
      V16086             405 - 405         ER30570            406 - 409         ER30571            410 - 411   
      ER30572            412 - 413         ER30573            414 - 416         ER30574            417 - 418   
      ER30575            419 - 422         V16301             423 - 423         V16628             424 - 427   
      V16631             428 - 429         V16633             430 - 431         V17418             432 - 432   
      V17483             433 - 433         ER30606            434 - 437         ER30607            438 - 439   
      ER30608            440 - 441         ER30609            442 - 444         ER30610            445 - 446   
      ER30611            447 - 450         V17701             451 - 451         V18046             452 - 455   
      V18049             456 - 457         V18051             458 - 459         V18749             460 - 460   
      V18814             461 - 461         ER30642            462 - 466         ER30643            467 - 468   
      ER30644            469 - 470         ER30645            471 - 473         ER30646            474 - 475   
      ER30647            476 - 479         V19001             480 - 480         V19346             481 - 484   
      V19349             485 - 486         V19351             487 - 488         V20049             489 - 489   
      V20114             490 - 490         ER30689            491 - 494         ER30690            495 - 496   
      ER30691            497 - 498         ER30692            499 - 501         ER30693            502 - 503   
      ER30694            504 - 507         V20301             508 - 508         V20648             509 - 512   
      V20651             513 - 514         V20653             515 - 516         V21355             517 - 517   
      V21420             518 - 518         ER30733            519 - 522         ER30734            523 - 524   
      ER30735            525 - 526         ER30736            527 - 529         ER30737            530 - 531   
      ER30738            532 - 535         V21601             536 - 536         V22403             537 - 540   
      V22406             541 - 542         V22408             543 - 544         V23212             545 - 545   
      V23276             546 - 546         ER30806            547 - 551         ER30807            552 - 553   
      ER30808            554 - 555         ER30809            556 - 558         ER30810            559 - 560   
      ER30811            561 - 564         ER2001             565 - 565         ER2005             566 - 569   
      ER2007             570 - 571         ER2009             572 - 573         ER3883             574 - 574   
      ER3944             575 - 575         ER33101            576 - 580         ER33102            581 - 582   
      ER33103            583 - 584         ER33104            585 - 587         ER33105            588 - 589   
      ER33106            590 - 593         ER5001             594 - 594         ER5004             595 - 598   
      ER5006             599 - 600         ER5008             601 - 602         ER6753             603 - 603   
      ER6814             604 - 604         ER33201            605 - 609         ER33202            610 - 611   
      ER33203            612 - 613         ER33204            614 - 616         ER33205            617 - 618   
      ER33206            619 - 622         ER7001             623 - 623         ER7004             624 - 627   
      ER7006             628 - 629         ER7008             630 - 631         ER8999             632 - 632   
      ER9060             633 - 633         ER33301            634 - 637         ER33302            638 - 639   
      ER33303            640 - 641         ER33304            642 - 644         ER33305            645 - 646   
      ER33306            647 - 650         ER10001            651 - 651         ER10009            652 - 654   
      ER10011            655 - 657         ER10086            658 - 658         ER10568            659 - 659   
      ER11760            660 - 660         ER11847            661 - 661         ER11848            662 - 662   
      ER33401            663 - 667         ER33402            668 - 669         ER33403            670 - 671   
      ER33404            672 - 674         ER33405            675 - 676         ER33406            677 - 680   
      ER33434            681 - 681         ER13001            682 - 682         ER13010            683 - 685   
      ER13012            686 - 688         ER13210            689 - 689         ER13722            690 - 690   
      ER15836            691 - 691         ER15927            692 - 692         ER15928            693 - 693   
      ER33501            694 - 698         ER33502            699 - 700         ER33503            701 - 702   
      ER33504            703 - 705         ER33505            706 - 707         ER33506            708 - 711   
      ER33542            712 - 712         ER17001            713 - 713         ER17013            714 - 716   
      ER17015            717 - 719         ER17221            720 - 720         ER17791            721 - 721   
      ER19897            722 - 722         ER19988            723 - 723         ER19989            724 - 724   
      ER33601            725 - 728         ER33602            729 - 730         ER33603            731 - 732   
      ER33604            733 - 735         ER33605            736 - 737         ER33606            738 - 741   
      ER33633            742 - 742         ER21001            743 - 743         ER21017            744 - 746   
      ER21019            747 - 749         ER21147            750 - 750         ER21397            751 - 751   
      ER23334            752 - 752         ER23425            753 - 753         ER23426            754 - 754   
      ER33701            755 - 759         ER33702            760 - 761         ER33703            762 - 763   
      ER33704            764 - 766         ER33705            767 - 768         ER33706            769 - 772   
      ER33736            773 - 773         ER25001            774 - 774         ER25017            775 - 777   
      ER25019            778 - 780         ER25129            781 - 781         ER25387            782 - 782   
      ER27297            783 - 783         ER27391            784 - 784         ER27393            785 - 785   
      ER33801            786 - 790         ER33802            791 - 792         ER33803            793 - 794   
      ER33804            795 - 797         ER33805            798 - 799         ER33806            800 - 803   
      ER33842            804 - 804         ER36001            805 - 805         ER36017            806 - 808   
      ER36019            809 - 811         ER36134            812 - 812         ER36392            813 - 813   
      ER40472            814 - 814         ER40563            815 - 815         ER40565            816 - 816   
      ER33901            817 - 821         ER33902            822 - 823         ER33903            824 - 825   
      ER33904            826 - 828         ER33905            829 - 830         ER33906            831 - 834   
      ER33942            835 - 835         ER42001            836 - 836         ER42017            837 - 839   
      ER42019            840 - 842         ER42169            843 - 843         ER42421            844 - 844   
      ER46447            845 - 845         ER46449            846 - 846         ER46541            847 - 847   
      ER46543            848 - 848         ER34001            849 - 853         ER34002            854 - 855   
      ER34003            856 - 857         ER34004            858 - 860         ER34005            861 - 862   
      ER34006            863 - 866         ER34036            867 - 867         ER47301            868 - 868   
      ER47317            869 - 871         ER47319            872 - 874         ER47482            875 - 875   
      ER47739            876 - 876         ER51808            877 - 877         ER51810            878 - 878   
      ER51902            879 - 879         ER51904            880 - 880         ER34101            881 - 885   
      ER34102            886 - 887         ER34103            888 - 889         ER34104            890 - 892   
      ER34105            893 - 894         ER34106            895 - 898         ER34148            899 - 899   
      ER53001            900 - 900         ER53017            901 - 903         ER53019            904 - 906   
      ER53182            907 - 907         ER53445            908 - 908         ER54305            909 - 909   
      ER57547            910 - 910         ER57549            911 - 911         ER57657            912 - 912   
      ER57659            913 - 913         ER34201            914 - 918         ER34202            919 - 920   
      ER34203            921 - 922         ER34204            923 - 925         ER34205            926 - 927   
      ER34206            928 - 931         ER34255            932 - 932         ER60001            933 - 933   
      ER60017            934 - 936         ER60019            937 - 939         ER60197            940 - 940   
      ER60460            941 - 941         ER61347            942 - 942         ER64669            943 - 943   
      ER64671            944 - 944         ER64808            945 - 945         ER64810            946 - 946   
      ER34301            947 - 951         ER34302            952 - 953         ER34303            954 - 955   
      ER34305            956 - 958         ER34306            959 - 960         ER34307            961 - 964   
      ER34405            965 - 965         ER66001            966 - 966         ER66017            967 - 969   
      ER66019            970 - 972         ER66198            973 - 973         ER66473            974 - 974   
      ER70742            975 - 975         ER70744            976 - 976         ER70880            977 - 977   
      ER70882            978 - 978         ER34501            979 - 983         ER34502            984 - 985   
      ER34503            986 - 987         ER34504            988 - 990         ER34505            991 - 992   
      ER34506            993 - 996         ER34644            997 - 997         ER72001            998 - 998   
      ER72017            999 - 1001        ER72019           1002 - 1004        ER72198           1005 - 1005  
      ER72475           1006 - 1006        ER76750           1007 - 1007        ER76752           1008 - 1008  
      ER76895           1009 - 1009        ER76897           1010 - 1010        ER34701           1011 - 1015  
      ER34702           1016 - 1017        ER34703           1018 - 1019        ER34704           1020 - 1022  
      ER34706           1023 - 1026        ER34853           1027 - 1027  
using ./RawData/extra_demographicvars.txt, clear 
;
label variable ER30000         "RELEASE NUMBER"                           ;
label variable ER30001         "1968 INTERVIEW NUMBER"                    ;
label variable ER30002         "PERSON NUMBER                         68" ;
label variable V1              "RELEASE NUMBER"                           ;
label variable V99             "DATE OF INTVW"                            ;
label variable V117            "AGE OF HEAD"                              ;
label variable V118            "AGE OF WIFE"                              ;
label variable ER30003         "RELATIONSHIP TO HEAD                  68" ;
label variable ER30004         "AGE OF INDIVIDUAL                     68" ;
label variable V441            "RELEASE NUMBER"                           ;
label variable V553            "DATE OF IW      1"                        ;
label variable V1008           "AGE OF HEAD"                              ;
label variable V1011           "AGE OF WIFE"                              ;
label variable ER30020         "1969 INTERVIEW NUMBER"                    ;
label variable ER30021         "SEQUENCE NUMBER                       69" ;
label variable ER30022         "RELATIONSHIP TO HEAD                  69" ;
label variable ER30023         "AGE OF INDIVIDUAL                     69" ;
label variable V1101           "RELEASE NUMBER"                           ;
label variable V1236           "DATE OF IW"                               ;
label variable V1239           "AGE OF HEAD"                              ;
label variable V1241           "AGE OF WIFE"                              ;
label variable ER30043         "1970 INTERVIEW NUMBER"                    ;
label variable ER30044         "SEQUENCE NUMBER                       70" ;
label variable ER30045         "RELATIONSHIP TO HEAD                  70" ;
label variable ER30046         "AGE OF INDIVIDUAL                     70" ;
label variable V1801           "RELEASE NUMBER"                           ;
label variable V1939           "DATE OF IW"                               ;
label variable V1942           "AGE OF HEAD"                              ;
label variable V1944           "AGE OF WIFE"                              ;
label variable ER30067         "1971 INTERVIEW NUMBER"                    ;
label variable ER30068         "SEQUENCE NUMBER                       71" ;
label variable ER30069         "RELATIONSHIP TO HEAD                  71" ;
label variable ER30070         "AGE OF INDIVIDUAL                     71" ;
label variable V2401           "RELEASE NUMBER"                           ;
label variable V2539           "DATE OF IW"                               ;
label variable V2542           "AGE OF HEAD"                              ;
label variable V2544           "AGE OF WIFE"                              ;
label variable ER30091         "1972 INTERVIEW NUMBER"                    ;
label variable ER30092         "SEQUENCE NUMBER                       72" ;
label variable ER30093         "RELATIONSHIP TO HEAD                  72" ;
label variable ER30094         "AGE OF INDIVIDUAL                     72" ;
label variable V3001           "RELEASE NUMBER"                           ;
label variable V3092           "DATE OF INTERVIEW"                        ;
label variable V3095           "AGE OF HEAD"                              ;
label variable V3097           "AGE OF WIFE"                              ;
label variable ER30117         "1973 INTERVIEW NUMBER"                    ;
label variable ER30118         "SEQUENCE NUMBER                       73" ;
label variable ER30119         "RELATIONSHIP TO HEAD                  73" ;
label variable ER30120         "AGE OF INDIVIDUAL                     73" ;
label variable V3401           "RELEASE NUMBER"                           ;
label variable V3505           "DATE OF INTERVIEW"                        ;
label variable V3508           "AGE OF HEAD"                              ;
label variable V3510           "AGE OF WIFE"                              ;
label variable ER30138         "1974 INTERVIEW NUMBER"                    ;
label variable ER30139         "SEQUENCE NUMBER                       74" ;
label variable ER30140         "RELATIONSHIP TO HEAD                  74" ;
label variable ER30141         "AGE OF INDIVIDUAL                     74" ;
label variable V3801           "RELEASE NUMBER"                           ;
label variable V3918           "DATE OF INT"                              ;
label variable V3921           "AGE OF HEAD"                              ;
label variable V3923           "AGE OF WIFE"                              ;
label variable ER30160         "1975 INTERVIEW NUMBER"                    ;
label variable ER30161         "SEQUENCE NUMBER                       75" ;
label variable ER30162         "RELATIONSHIP TO HEAD                  75" ;
label variable ER30163         "AGE OF INDIVIDUAL                     75" ;
label variable V4301           "RELEASE NUMBER"                           ;
label variable V4433           "DATE OF INTERVIEW"                        ;
label variable V4436           "AGE OF HEAD"                              ;
label variable V4438           "AGE OF WIFE"                              ;
label variable V4741           "DATE OF WF INT"                           ;
label variable ER30188         "1976 INTERVIEW NUMBER"                    ;
label variable ER30189         "SEQUENCE NUMBER                       76" ;
label variable ER30190         "RELATIONSHIP TO HEAD                  76" ;
label variable ER30191         "AGE OF INDIVIDUAL                     76" ;
label variable V5201           "RELEASE NUMBER"                           ;
label variable V5347           "DATE OF INT"                              ;
label variable V5350           "AGE OF HEAD"                              ;
label variable V5352           "AGE OF WIFE"                              ;
label variable ER30217         "1977 INTERVIEW NUMBER"                    ;
label variable ER30218         "SEQUENCE NUMBER                       77" ;
label variable ER30219         "RELATIONSHIP TO HEAD                  77" ;
label variable ER30220         "AGE OF INDIVIDUAL                     77" ;
label variable V5701           "RELEASE NUMBER"                           ;
label variable V5847           "DATE OF INT"                              ;
label variable V5850           "AGE OF HEAD"                              ;
label variable V5852           "AGE OF WIFE"                              ;
label variable ER30246         "1978 INTERVIEW NUMBER"                    ;
label variable ER30247         "SEQUENCE NUMBER                       78" ;
label variable ER30248         "RELATIONSHIP TO HEAD                  78" ;
label variable ER30249         "AGE OF INDIVIDUAL                     78" ;
label variable V6301           "RELEASE NUMBER"                           ;
label variable V6459           "DATE OF INT"                              ;
label variable V6462           "AGE OF HEAD"                              ;
label variable V6464           "AGE OF WIFE"                              ;
label variable ER30283         "1979 INTERVIEW NUMBER"                    ;
label variable ER30284         "SEQUENCE NUMBER                       79" ;
label variable ER30285         "RELATIONSHIP TO HEAD                  79" ;
label variable ER30286         "AGE OF INDIVIDUAL                     79" ;
label variable V6901           "RELEASE NUMBER"                           ;
label variable V7064           "DATE OF INT"                              ;
label variable V7067           "AGE OF HEAD"                              ;
label variable V7069           "AGE OF WIFE"                              ;
label variable ER30313         "1980 INTERVIEW NUMBER"                    ;
label variable ER30314         "SEQUENCE NUMBER                       80" ;
label variable ER30315         "RELATIONSHIP TO HEAD                  80" ;
label variable ER30316         "AGE OF INDIVIDUAL                     80" ;
label variable V7501           "RELEASE NUMBER"                           ;
label variable V7655           "DATE OF 1981 INT"                         ;
label variable V7658           "AGE OF 1981 HEAD"                         ;
label variable V7660           "AGE OF 1981 WIFE"                         ;
label variable ER30343         "1981 INTERVIEW NUMBER"                    ;
label variable ER30344         "SEQUENCE NUMBER                       81" ;
label variable ER30345         "RELATIONSHIP TO HEAD                  81" ;
label variable ER30346         "AGE OF INDIVIDUAL                     81" ;
label variable V8201           "RELEASE NUMBER"                           ;
label variable V8349           "DATE OF 1982 INT"                         ;
label variable V8352           "AGE OF 1982 HEAD"                         ;
label variable V8354           "AGE OF 1982 WIFE"                         ;
label variable ER30373         "1982 INTERVIEW NUMBER"                    ;
label variable ER30374         "SEQUENCE NUMBER                       82" ;
label variable ER30375         "RELATIONSHIP TO HEAD                  82" ;
label variable ER30376         "AGE OF INDIVIDUAL                     82" ;
label variable V8801           "RELEASE NUMBER"                           ;
label variable V8958           "DATE OF 1983 INT"                         ;
label variable V8961           "AGE OF 1983 HEAD"                         ;
label variable V8963           "AGE OF 1983 WIFE"                         ;
label variable V9408           "RACE (FROM 1972)"                         ;
label variable ER30399         "1983 INTERVIEW NUMBER"                    ;
label variable ER30400         "SEQUENCE NUMBER                       83" ;
label variable ER30401         "RELATIONSHIP TO HEAD                  83" ;
label variable ER30402         "AGE OF INDIVIDUAL                     83" ;
label variable ER30403         "MONTH IND BORN                        83" ;
label variable ER30404         "YEAR IND BORN                         83" ;
label variable V10001          "RELEASE NUMBER"                           ;
label variable V10416          "DATE OF 1984 INT"                         ;
label variable V10419          "AGE OF 1984 HEAD"                         ;
label variable V10421          "AGE OF 1984 WIFE"                         ;
label variable V11055          "RACE (FROM 1972)"                         ;
label variable ER30429         "1984 INTERVIEW NUMBER"                    ;
label variable ER30430         "SEQUENCE NUMBER                       84" ;
label variable ER30431         "RELATIONSHIP TO HEAD                  84" ;
label variable ER30432         "AGE OF INDIVIDUAL                     84" ;
label variable ER30433         "MONTH IND BORN                        84" ;
label variable ER30434         "YEAR IND BORN                         84" ;
label variable V11101          "RELEASE NUMBER"                           ;
label variable V11600          "DATE OF 1985 IW-HEAD"                     ;
label variable V11603          "DATE OF 1985 IW-WIFE"                     ;
label variable V11606          "AGE OF 1985 HEAD"                         ;
label variable V11608          "AGE OF 1985 WIFE"                         ;
label variable V11938          "G32 RACE OF HEAD (1 MEN)"                 ;
label variable V12293          "N32 RACE OF WIFE (1 MEN)"                 ;
label variable ER30463         "1985 INTERVIEW NUMBER"                    ;
label variable ER30464         "SEQUENCE NUMBER                       85" ;
label variable ER30465         "RELATIONSHIP TO HEAD                  85" ;
label variable ER30466         "AGE OF INDIVIDUAL                     85" ;
label variable ER30467         "MONTH IND BORN                        85" ;
label variable ER30468         "YEAR IND BORN                         85" ;
label variable V12501          "RELEASE NUMBER"                           ;
label variable V13008          "DATE OF 1986 IW"                          ;
label variable V13011          "AGE OF 1986 HEAD"                         ;
label variable V13013          "AGE OF 1986 WIFE"                         ;
label variable V13500          "K19 RACE OF WIFE 1"                       ;
label variable V13565          "L32 RACE OF HEAD 1"                       ;
label variable ER30498         "1986 INTERVIEW NUMBER"                    ;
label variable ER30499         "SEQUENCE NUMBER                       86" ;
label variable ER30500         "RELATIONSHIP TO HEAD                  86" ;
label variable ER30501         "AGE OF INDIVIDUAL                     86" ;
label variable ER30502         "MONTH IND BORN                        86" ;
label variable ER30503         "YEAR IND BORN                         86" ;
label variable V13701          "RELEASE NUMBER"                           ;
label variable V14111          "DATE OF 1987 IW"                          ;
label variable V14114          "AGE OF 1987 HEAD"                         ;
label variable V14116          "AGE OF 1987 WIFE"                         ;
label variable V14547          "K19 RACE OF WIFE 1"                       ;
label variable V14612          "L32 RACE OF HEAD 1"                       ;
label variable ER30535         "1987 INTERVIEW NUMBER"                    ;
label variable ER30536         "SEQUENCE NUMBER                       87" ;
label variable ER30537         "RELATIONSHIP TO HEAD                  87" ;
label variable ER30538         "AGE OF INDIVIDUAL                     87" ;
label variable ER30539         "MONTH IND BORN                        87" ;
label variable ER30540         "YEAR IND BORN                         87" ;
label variable V14801          "RELEASE NUMBER"                           ;
label variable V15127          "DATE OF 1988 IW"                          ;
label variable V15130          "AGE OF 1988 HEAD"                         ;
label variable V15132          "AGE OF 1988 WIFE"                         ;
label variable V16021          "K19 RACE OF WIFE 1"                       ;
label variable V16086          "L32 RACE OF HEAD 1"                       ;
label variable ER30570         "1988 INTERVIEW NUMBER"                    ;
label variable ER30571         "SEQUENCE NUMBER                       88" ;
label variable ER30572         "RELATION TO HEAD                      88" ;
label variable ER30573         "AGE OF INDIVIDUAL                     88" ;
label variable ER30574         "MONTH INDIVIDUAL BORN                 88" ;
label variable ER30575         "YEAR INDIVIDUAL BORN                  88" ;
label variable V16301          "RELEASE NUMBER"                           ;
label variable V16628          "DATE OF 1989 IW"                          ;
label variable V16631          "AGE OF 1989 HEAD"                         ;
label variable V16633          "AGE OF 1989 WIFE"                         ;
label variable V17418          "K19 RACE OF WIFE 1"                       ;
label variable V17483          "L32 RACE OF HEAD 1"                       ;
label variable ER30606         "1989 INTERVIEW NUMBER"                    ;
label variable ER30607         "SEQUENCE NUMBER                       89" ;
label variable ER30608         "RELATION TO HEAD                      89" ;
label variable ER30609         "AGE OF INDIVIDUAL                     89" ;
label variable ER30610         "MONTH INDIVIDUAL BORN                 89" ;
label variable ER30611         "YEAR INDIVIDUAL BORN                  89" ;
label variable V17701          "RELEASE NUMBER"                           ;
label variable V18046          "DATE OF 1990 IW"                          ;
label variable V18049          "AGE OF 1990 HEAD"                         ;
label variable V18051          "AGE OF 1990 WIFE"                         ;
label variable V18749          "L19 RACE OF WIFE 1"                       ;
label variable V18814          "M32 RACE OF HEAD 1"                       ;
label variable ER30642         "1990 INTERVIEW NUMBER"                    ;
label variable ER30643         "SEQUENCE NUMBER                       90" ;
label variable ER30644         "RELATION TO HEAD                      90" ;
label variable ER30645         "AGE OF INDIVIDUAL                     90" ;
label variable ER30646         "MONTH INDIVIDUAL BORN                 90" ;
label variable ER30647         "YEAR INDIVIDUAL BORN                  90" ;
label variable V19001          "RELEASE NUMBER"                           ;
label variable V19346          "DATE OF 1991 IW"                          ;
label variable V19349          "AGE OF 1991 HEAD"                         ;
label variable V19351          "AGE OF 1991 WIFE"                         ;
label variable V20049          "K19 RACE OF WIFE 1"                       ;
label variable V20114          "L32 RACE OF HEAD 1"                       ;
label variable ER30689         "1991 INTERVIEW NUMBER"                    ;
label variable ER30690         "SEQUENCE NUMBER                       91" ;
label variable ER30691         "RELATION TO HEAD                      91" ;
label variable ER30692         "AGE OF INDIVIDUAL                     91" ;
label variable ER30693         "MONTH INDIVIDUAL BORN                 91" ;
label variable ER30694         "YEAR INDIVIDUAL BORN                  91" ;
label variable V20301          "RELEASE NUMBER"                           ;
label variable V20648          "DATE OF 1992 IW"                          ;
label variable V20651          "AGE OF 1992 HEAD"                         ;
label variable V20653          "AGE OF 1992 WIFE"                         ;
label variable V21355          "L19 RACE OF WIFE 1"                       ;
label variable V21420          "M32 RACE OF HEAD 1"                       ;
label variable ER30733         "1992 INTERVIEW NUMBER"                    ;
label variable ER30734         "SEQUENCE NUMBER                       92" ;
label variable ER30735         "RELATION TO HEAD                      92" ;
label variable ER30736         "AGE OF INDIVIDUAL                     92" ;
label variable ER30737         "MONTH IND BORN                        92" ;
label variable ER30738         "YEAR IND BORN                         92" ;
label variable V21601          "RELEASE NUMBER"                           ;
label variable V22403          "3. DATE OF 1993 INTERVIEW"                ;
label variable V22406          "AGE OF 1993 HEAD"                         ;
label variable V22408          "AGE OF 1993 WIFE"                         ;
label variable V23212          "K19 RACE OF WF-1ST MENTION"               ;
label variable V23276          "L32 RACE OF HD-1ST MENTION"               ;
label variable ER30806         "1993 INTERVIEW NUMBER"                    ;
label variable ER30807         "SEQUENCE NUMBER                       93" ;
label variable ER30808         "RELATION TO HEAD                      93" ;
label variable ER30809         "AGE OF INDIVIDUAL                     93" ;
label variable ER30810         "MONTH INDIVIDUAL BORN                 93" ;
label variable ER30811         "YEAR INDIVIDUAL BORN                  93" ;
label variable ER2001          "RELEASE NUMBER"                           ;
label variable ER2005          "DATE OF INTERVIEW"                        ;
label variable ER2007          "AGE OF HEAD"                              ;
label variable ER2009          "AGE OF WIFE"                              ;
label variable ER3883          "K19 RACE OF WIFE      1"                  ;
label variable ER3944          "L32 RACE OF HEAD      1"                  ;
label variable ER33101         "1994 INTERVIEW NUMBER"                    ;
label variable ER33102         "SEQUENCE NUMBER                       94" ;
label variable ER33103         "RELATION TO HEAD                      94" ;
label variable ER33104         "AGE OF INDIVIDUAL                     94" ;
label variable ER33105         "MONTH INDIVIDUAL BORN                 94" ;
label variable ER33106         "YEAR INDIVIDUAL BORN                  94" ;
label variable ER5001          "RELEASE NUMBER"                           ;
label variable ER5004          "DATE OF INTERVIEW"                        ;
label variable ER5006          "AGE OF HEAD"                              ;
label variable ER5008          "AGE OF WIFE"                              ;
label variable ER6753          "K19 RACE OF WIFE      1"                  ;
label variable ER6814          "L32 RACE OF HEAD      1"                  ;
label variable ER33201         "1995 INTERVIEW NUMBER"                    ;
label variable ER33202         "SEQUENCE NUMBER                       95" ;
label variable ER33203         "RELATION TO HEAD                      95" ;
label variable ER33204         "AGE OF INDIVIDUAL                     95" ;
label variable ER33205         "MONTH INDIVIDUAL BORN                 95" ;
label variable ER33206         "YEAR INDIVIDUAL BORN                  95" ;
label variable ER7001          "RELEASE NUMBER"                           ;
label variable ER7004          "DATE OF INTERVIEW"                        ;
label variable ER7006          "AGE OF HEAD"                              ;
label variable ER7008          "AGE OF WIFE"                              ;
label variable ER8999          "K19 RACE OF WIFE      1"                  ;
label variable ER9060          "L32 RACE OF HEAD      1"                  ;
label variable ER33301         "1996 INTERVIEW NUMBER"                    ;
label variable ER33302         "SEQUENCE NUMBER                       96" ;
label variable ER33303         "RELATION TO HEAD                      96" ;
label variable ER33304         "AGE OF INDIVIDUAL                     96" ;
label variable ER33305         "MONTH INDIVIDUAL BORN                 96" ;
label variable ER33306         "YEAR INDIVIDUAL BORN                  96" ;
label variable ER10001         "RELEASE NUMBER"                           ;
label variable ER10009         "AGE OF HEAD"                              ;
label variable ER10011         "AGE OF WIFE"                              ;
label variable ER10086         "B4 WORK SELF/OTR? (HD-E)"                 ;
label variable ER10568         "D4 WORK SELF/OTR? (WF-E)"                 ;
label variable ER11760         "K34/87 RACE OF WIFE 1"                    ;
label variable ER11847         "L39 LIVE W/BOTH PARENTS"                  ;
label variable ER11848         "L40/95 RACE OF HEAD 1"                    ;
label variable ER33401         "1997 INTERVIEW NUMBER"                    ;
label variable ER33402         "SEQUENCE NUMBER                       97" ;
label variable ER33403         "RELATION TO HEAD                      97" ;
label variable ER33404         "AGE OF INDIVIDUAL                     97" ;
label variable ER33405         "MONTH INDIVIDUAL BORN                 97" ;
label variable ER33406         "YEAR INDIVIDUAL BORN                  97" ;
label variable ER33434         "FOLLOW STATUS                         97" ;
label variable ER13001         "RELEASE NUMBER"                           ;
label variable ER13010         "AGE OF HEAD"                              ;
label variable ER13012         "AGE OF WIFE"                              ;
label variable ER13210         "B4 WORK SELF/OTR? (HD-E)"                 ;
label variable ER13722         "D4 WORK SELF/OTR? (WF-E)"                 ;
label variable ER15836         "K34/87 RACE OF WIFE 1"                    ;
label variable ER15927         "L38 LIVE W/BOTH PARENTS"                  ;
label variable ER15928         "L40/95 RACE OF HEAD 1"                    ;
label variable ER33501         "1999 INTERVIEW NUMBER"                    ;
label variable ER33502         "SEQUENCE NUMBER                       99" ;
label variable ER33503         "RELATION TO HEAD                      99" ;
label variable ER33504         "AGE OF INDIVIDUAL                     99" ;
label variable ER33505         "MONTH INDIVIDUAL BORN                 99" ;
label variable ER33506         "YEAR INDIVIDUAL BORN                  99" ;
label variable ER33542         "FOLLOW STATUS                         99" ;
label variable ER17001         "RELEASE NUMBER"                           ;
label variable ER17013         "AGE OF HEAD"                              ;
label variable ER17015         "AGE OF WIFE"                              ;
label variable ER17221         "B4 WORK SELF/OTR? (HD-E)"                 ;
label variable ER17791         "D4 WORK SELF/OTR? (WF-E)"                 ;
label variable ER19897         "K34/87 RACE OF WIFE 1"                    ;
label variable ER19988         "L39 LIVE W/BOTH PARENTS"                  ;
label variable ER19989         "L40/95 RACE OF HEAD 1"                    ;
label variable ER33601         "2001 INTERVIEW NUMBER"                    ;
label variable ER33602         "SEQUENCE NUMBER                       01" ;
label variable ER33603         "RELATION TO HEAD                      01" ;
label variable ER33604         "AGE OF INDIVIDUAL                     01" ;
label variable ER33605         "MONTH INDIVIDUAL BORN                 01" ;
label variable ER33606         "YEAR INDIVIDUAL BORN                  01" ;
label variable ER33633         "FOLLOW STATUS                         01" ;
label variable ER21001         "RELEASE NUMBER"                           ;
label variable ER21017         "AGE OF HEAD"                              ;
label variable ER21019         "AGE OF WIFE"                              ;
label variable ER21147         "BC22 WORK SELF/OTR?--JOB 1"               ;
label variable ER21397         "DE22 WORK SELF/OTR?--JOB 1"               ;
label variable ER23334         "K34/87 RACE OF WIFE 1"                    ;
label variable ER23425         "L39 LIVE W/BOTH PARENTS"                  ;
label variable ER23426         "L40/95 RACE OF HEAD 1"                    ;
label variable ER33701         "2003 INTERVIEW NUMBER"                    ;
label variable ER33702         "SEQUENCE NUMBER                       03" ;
label variable ER33703         "RELATION TO HEAD                      03" ;
label variable ER33704         "AGE OF INDIVIDUAL                     03" ;
label variable ER33705         "MONTH INDIVIDUAL BORN                 03" ;
label variable ER33706         "YEAR INDIVIDUAL BORN                  03" ;
label variable ER33736         "FOLLOW STATUS                         03" ;
label variable ER25001         "RELEASE NUMBER"                           ;
label variable ER25017         "AGE OF HEAD"                              ;
label variable ER25019         "AGE OF WIFE"                              ;
label variable ER25129         "BC22 WORK SELF/OTR?--JOB 1"               ;
label variable ER25387         "DE22 WORK SELF/OTR?--JOB 1"               ;
label variable ER27297         "K34 RACE OF WIFE-MENTION 1"               ;
label variable ER27391         "L39 WTR LIVED W/BOTH PARENTS-HD"          ;
label variable ER27393         "L40 RACE OF HEAD-MENTION 1"               ;
label variable ER33801         "2005 INTERVIEW NUMBER"                    ;
label variable ER33802         "SEQUENCE NUMBER                       05" ;
label variable ER33803         "RELATION TO HEAD                      05" ;
label variable ER33804         "AGE OF INDIVIDUAL                     05" ;
label variable ER33805         "MONTH INDIVIDUAL BORN                 05" ;
label variable ER33806         "YEAR INDIVIDUAL BORN                  05" ;
label variable ER33842         "FOLLOW STATUS                         05" ;
label variable ER36001         "RELEASE NUMBER"                           ;
label variable ER36017         "AGE OF HEAD"                              ;
label variable ER36019         "AGE OF WIFE"                              ;
label variable ER36134         "BC22 WORK SELF/OTR?--JOB 1"               ;
label variable ER36392         "DE22 WORK SELF/OTR?--JOB 1"               ;
label variable ER40472         "K40 RACE OF WIFE-MENTION 1"               ;
label variable ER40563         "L38 WTR LIVED W/BOTH PARENTS-HD"          ;
label variable ER40565         "L40 RACE OF HEAD-MENTION 1"               ;
label variable ER33901         "2007 INTERVIEW NUMBER"                    ;
label variable ER33902         "SEQUENCE NUMBER                       07" ;
label variable ER33903         "RELATION TO HEAD                      07" ;
label variable ER33904         "AGE OF INDIVIDUAL                     07" ;
label variable ER33905         "MONTH INDIVIDUAL BORN                 07" ;
label variable ER33906         "YEAR INDIVIDUAL BORN                  07" ;
label variable ER33942         "FOLLOW STATUS                         07" ;
label variable ER42001         "RELEASE NUMBER"                           ;
label variable ER42017         "AGE OF HEAD"                              ;
label variable ER42019         "AGE OF WIFE"                              ;
label variable ER42169         "BC22 WORK SELF/OTR?--JOB 1"               ;
label variable ER42421         "DE22 WORK SELF/OTR?--JOB 1"               ;
label variable ER46447         "K38 WTR LIVED W/BOTH PARENTS-WF"          ;
label variable ER46449         "K40 RACE OF WIFE-MENTION 1"               ;
label variable ER46541         "L38 WTR LIVED W/BOTH PARENTS-HD"          ;
label variable ER46543         "L40 RACE OF HEAD-MENTION 1"               ;
label variable ER34001         "2009 INTERVIEW NUMBER"                    ;
label variable ER34002         "SEQUENCE NUMBER                       09" ;
label variable ER34003         "RELATION TO HEAD                      09" ;
label variable ER34004         "AGE OF INDIVIDUAL                     09" ;
label variable ER34005         "MONTH INDIVIDUAL BORN                 09" ;
label variable ER34006         "YEAR INDIVIDUAL BORN                  09" ;
label variable ER34036         "FOLLOW STATUS                         09" ;
label variable ER47301         "RELEASE NUMBER"                           ;
label variable ER47317         "AGE OF HEAD"                              ;
label variable ER47319         "AGE OF WIFE"                              ;
label variable ER47482         "BC22 WORK SELF/OTR?--JOB 1"               ;
label variable ER47739         "DE22 WORK SELF/OTR?--JOB 1"               ;
label variable ER51808         "K38 WTR LIVED W/BOTH PARENTS-WF"          ;
label variable ER51810         "K40 RACE OF WIFE-MENTION 1"               ;
label variable ER51902         "L38 WTR LIVED W/BOTH PARENTS-HD"          ;
label variable ER51904         "L40 RACE OF HEAD-MENTION 1"               ;
label variable ER34101         "2011 INTERVIEW NUMBER"                    ;
label variable ER34102         "SEQUENCE NUMBER                       11" ;
label variable ER34103         "RELATION TO HEAD                      11" ;
label variable ER34104         "AGE OF INDIVIDUAL                     11" ;
label variable ER34105         "MONTH INDIVIDUAL BORN                 11" ;
label variable ER34106         "YEAR INDIVIDUAL BORN                  11" ;
label variable ER34148         "FOLLOW STATUS                         11" ;
label variable ER53001         "RELEASE NUMBER"                           ;
label variable ER53017         "AGE OF HEAD"                              ;
label variable ER53019         "AGE OF WIFE"                              ;
label variable ER53182         "BC22 WORK SELF/OTR?--JOB 1"               ;
label variable ER53445         "DE22 WORK SELF/OTR?--JOB 1"               ;
label variable ER54305         "G49 WTR WIFE IN FU NOW"                   ;
label variable ER57547         "K38 WTR LIVED W/BOTH PARENTS-WF"          ;
label variable ER57549         "K40 RACE OF WIFE-MENTION 1"               ;
label variable ER57657         "L38 WTR LIVED W/BOTH PARENTS-HD"          ;
label variable ER57659         "L40 RACE OF HEAD-MENTION 1"               ;
label variable ER34201         "2013 INTERVIEW NUMBER"                    ;
label variable ER34202         "SEQUENCE NUMBER                       13" ;
label variable ER34203         "RELATION TO HEAD                      13" ;
label variable ER34204         "AGE OF INDIVIDUAL                     13" ;
label variable ER34205         "MONTH INDIVIDUAL BORN                 13" ;
label variable ER34206         "YEAR INDIVIDUAL BORN                  13" ;
label variable ER34255         "FOLLOW STATUS                         13" ;
label variable ER60001         "RELEASE NUMBER"                           ;
label variable ER60017         "AGE OF HEAD"                              ;
label variable ER60019         "AGE OF SPOUSE"                            ;
label variable ER60197         "BC22 WORK SELF/OTR?--JOB 1"               ;
label variable ER60460         "DE22 WORK SELF/OTR?--JOB 1"               ;
label variable ER61347         "G49 WTR SPOUSE IN FU NOW"                 ;
label variable ER64669         "K38 WTR LIVED W/BOTH PARENTS-SP"          ;
label variable ER64671         "K40 RACE OF SPOUSE-MENTION 1"             ;
label variable ER64808         "L38 WTR LIVED W/BOTH PARENTS-HD"          ;
label variable ER64810         "L40 RACE OF HEAD-MENTION 1"               ;
label variable ER34301         "2015 INTERVIEW NUMBER"                    ;
label variable ER34302         "SEQUENCE NUMBER                       15" ;
label variable ER34303         "RELATION TO HEAD                      15" ;
label variable ER34305         "AGE OF INDIVIDUAL                     15" ;
label variable ER34306         "MONTH INDIVIDUAL BORN                 15" ;
label variable ER34307         "YEAR INDIVIDUAL BORN                  15" ;
label variable ER34405         "FOLLOW STATUS                         15" ;
label variable ER66001         "RELEASE NUMBER"                           ;
label variable ER66017         "AGE OF REFERENCE PERSON"                  ;
label variable ER66019         "AGE OF SPOUSE"                            ;
label variable ER66198         "BC22 WORK SELF/OTR?--JOB 1"               ;
label variable ER66473         "DE22 WORK SELF/OTR?--JOB 1"               ;
label variable ER70742         "K38 WTR LIVED W/BOTH PARENTS-SP"          ;
label variable ER70744         "K40 RACE OF SPOUSE-MENTION 1"             ;
label variable ER70880         "L38 WTR LIVED W/BOTH PARENTS-RP"          ;
label variable ER70882         "L40 RACE OF REFERENCE PERSON-MENTION 1"   ;
label variable ER34501         "2017 INTERVIEW NUMBER"                    ;
label variable ER34502         "SEQUENCE NUMBER                       17" ;
label variable ER34503         "RELATION TO REFERENCE PERSON          17" ;
label variable ER34504         "AGE OF INDIVIDUAL                     17" ;
label variable ER34505         "MONTH INDIVIDUAL BORN                 17" ;
label variable ER34506         "YEAR INDIVIDUAL BORN                  17" ;
label variable ER34644         "FOLLOW STATUS                         17" ;
label variable ER72001         "RELEASE NUMBER"                           ;
label variable ER72017         "AGE OF REFERENCE PERSON"                  ;
label variable ER72019         "AGE OF SPOUSE"                            ;
label variable ER72198         "BC22 WORK SELF/OTR?--JOB 1"               ;
label variable ER72475         "DE22 WORK SELF/OTR?--JOB 1"               ;
label variable ER76750         "K38 WTR LIVED W/BOTH PARENTS-SP"          ;
label variable ER76752         "K40 RACE OF SPOUSE-MENTION 1"             ;
label variable ER76895         "L38 WTR LIVED W/BOTH PARENTS-RP"          ;
label variable ER76897         "L40 RACE OF REFERENCE PERSON-MENTION 1"   ;
label variable ER34701         "2019 INTERVIEW NUMBER"                    ;
label variable ER34702         "SEQUENCE NUMBER                       19" ;
label variable ER34703         "RELATION TO REFERENCE PERSON          19" ;
label variable ER34704         "AGE OF INDIVIDUAL                     19" ;
label variable ER34706         "YEAR INDIVIDUAL BORN                  19" ;
label variable ER34853         "FOLLOW STATUS                         19" ;

#delimit cr

***************************************************************
do ./RawData/extra_demographicvars_formats.do //PSID-provided cleaning
***************************************************************

// CREATE SON_ID
   ren ER30001 famid
   ren ER30002 personnumber

   gen son_id = famid*1000 + personnumber
   label var son_id "Child 1968 ID"
   duplicates report son_id //no dups

 //RENAME AGE VARS

   *AGE INDIVIDUAL 
   ren ER30004 ageind_1968 
   ren ER30023 ageind_1969 
   ren ER30046 ageind_1970 
   ren ER30070 ageind_1971
   ren ER30094 ageind_1972
   ren ER30120 ageind_1973 
   ren ER30141 ageind_1974 
   ren ER30163 ageind_1975
   ren ER30191 ageind_1976 
   ren ER30220 ageind_1977 
   ren ER30249 ageind_1978 
   ren ER30286 ageind_1979 
   ren ER30316 ageind_1980 
   ren ER30346 ageind_1981 
   ren ER30376 ageind_1982 
   ren ER30402 ageind_1983 
   ren ER30432 ageind_1984 
   ren ER30466 ageind_1985 
   ren ER30501 ageind_1986 
   ren ER30538 ageind_1987 
   ren ER30573 ageind_1988
   ren ER30609 ageind_1989 
   ren ER30645 ageind_1990 
   ren ER30692 ageind_1991 
   ren ER30736 ageind_1992 
   ren ER30809 ageind_1993 
   ren ER33104 ageind_1994 
   ren ER33204 ageind_1995 
   ren ER33304 ageind_1996 
   ren ER33404 ageind_1997 
   ren ER33504 ageind_1999 
   ren ER33604 ageind_2001 
   ren ER33704 ageind_2003 
   ren ER33804 ageind_2005 
   ren ER33904 ageind_2007 
   ren ER34004 ageind_2009 
   ren ER34104 ageind_2011 
   ren ER34204 ageind_2013 
   ren ER34305 ageind_2015 
   ren ER34504 ageind_2017 
   ren ER34704 ageind_2019

   *AGE OF HEAD AND SPOUSE
   ren V117 agehead_1968
   ren V118 agespouse_1968

   ren V1008 agehead_1969  
   ren V1011 agespouse_1969

   ren V1239 agehead_1970
   ren V1241 agespouse_1970

   ren V1942 agehead_1971
   ren V1944 agespouse_1971

   ren V2542 agehead_1972
   ren V2544 agespouse_1972

   ren V3095 agehead_1973
   ren V3097 agespouse_1973  

   ren V3508 agehead_1974
   ren V3510 agespouse_1974 

   ren V3921 agehead_1975
   ren V3923 agespouse_1975

   ren V4436 agehead_1976
   ren V4438 agespouse_1976

   ren V5350 agehead_1977
   ren V5352 agespouse_1977

   ren V5850 agehead_1978
   ren V5852 agespouse_1978

   ren V6462 agehead_1979
   ren V6464 agespouse_1979

   ren V7067 agehead_1980
   ren V7069 agespouse_1980

   ren V7658 agehead_1981
   ren V7660 agespouse_1981

   ren V8352 agehead_1982
   ren V8354 agespouse_1982

   ren V8961 agehead_1983
   ren V8963 agespouse_1983

   ren V10419 agehead_1984
   ren V10421 agespouse_1984

   ren V11606 agehead_1985
   ren V11608 agespouse_1985

   ren V13011 agehead_1986
   ren V13013 agespouse_1986

   ren V14114 agehead_1987
   ren V14116 agespouse_1987

   ren V15130 agehead_1988
   ren V15132 agespouse_1988

   ren V16631 agehead_1989
   ren V16633 agespouse_1989

   ren V18049 agehead_1990
   ren V18051 agespouse_1990

   ren V19349 agehead_1991
   ren V19351 agespouse_1991

   ren V20651 agehead_1992
   ren V20653 agespouse_1992

   ren V22406 agehead_1993
   ren V22408 agespouse_1993

   ren ER2007 agehead_1994
   ren ER2009 agespouse_1994

   ren ER5006 agehead_1995
   ren ER5008 agespouse_1995

   ren ER7006 agehead_1996
   ren ER7008 agespouse_1996 

   ren ER10009 agehead_1997
   ren ER10011 agespouse_1997

   ren ER13010 agehead_1999
   ren ER13012 agespouse_1999

   ren ER17013 agehead_2001
   ren ER17015 agespouse_2001

   ren ER21017 agehead_2003
   ren ER21019 agespouse_2003

   ren ER25017 agehead_2005
   ren ER25019 agespouse_2005 

   ren ER36017 agehead_2007
   ren ER36019 agespouse_2007

   ren ER42017 agehead_2009
   ren ER42019 agespouse_2009

   ren ER47317 agehead_2011
   ren ER47319 agespouse_2011

   ren ER53017 agehead_2013
   ren ER53019 agespouse_2013

   ren ER60017 agehead_2015
   ren ER60019 agespouse_2015

   ren ER66017 agehead_2017
   ren ER66019 agespouse_2017

   ren ER72017 agehead_2019
   ren ER72019 agespouse_2019

 //RENAME RACE VARS
   ren V9408 racehead_1983 
   ren V11055 racehead_1984

   ren V12293 racespouse_1985
   ren V11938 racehead_1985

   ren V13500 racespouse_1986
   ren V13565 racehead_1986

   ren V14547 racespouse_1987
   ren V14612 racehead_1987

   ren V16021 racespouse_1988
   ren V16086 racehead_1988

   ren V17418 racespouse_1989
   ren V17483 racehead_1989

   ren V18749 racespouse_1990
   ren V18814 racehead_1990

   ren V20049 racespouse_1991
   ren V20114 racehead_1991

   ren V21355 racespouse_1992
   ren V21420 racehead_1992

   ren V23212 racespouse_1993
   ren V23276 racehead_1993

   ren ER3883 racespouse_1994
   ren ER3944 racehead_1994

   ren ER6753 racespouse_1995
   ren ER6814 racehead_1995

   ren ER8999 racespouse_1996
   ren ER9060 racehead_1996

   ren ER11760 racespouse_1997
   ren ER11848 racehead_1997 

   ren ER15836 racespouse_1999
   ren ER15928 racehead_1999

   ren ER19897 racespouse_2001
   ren ER19989 racehead_2001

   ren ER23334 racespouse_2003
   ren ER23426 racehead_2003

   ren ER27297 racespouse_2005
   ren ER27393 racehead_2005

   ren ER40472 racespouse_2007
   ren ER40565 racehead_2007

   ren ER46449 racespouse_2009
   ren ER46543 racehead_2009

   ren ER51810 racespouse_2011
   ren ER51904 racehead_2011

   ren ER57549 racespouse_2013
   ren ER57659 racehead_2013

   ren ER64671 racespouse_2015
   ren ER64810 racehead_2015

   ren ER70744 racespouse_2017
   ren ER70882 racehead_2017

   ren ER76752 racespouse_2019
   ren ER76897 racehead_2019

  //RENAME SELF-EMPLOYED VARS
   ren ER10086  selfemployed_head_1997
   ren ER10568  selfemployed_spouse_1997

   ren ER13210  selfemployed_head_1999
   ren ER13722  selfemployed_spouse_1999

   ren ER17221  selfemployed_head_2001
   ren ER17791  selfemployed_spouse_2001

   ren ER21147  selfemployed_head_2003
   ren ER21397  selfemployed_spouse_2003

   ren ER25129  selfemployed_head_2005
   ren ER25387  selfemployed_spouse_2005

   ren ER36134  selfemployed_head_2007
   ren ER36392  selfemployed_spouse_2007

   ren ER42169  selfemployed_head_2009
   ren ER42421  selfemployed_spouse_2009

   ren ER47482  selfemployed_head_2011
   ren ER47739  selfemployed_spouse_2011

   ren ER53182  selfemployed_head_2013
   ren ER53445  selfemployed_spouse_2013

   ren ER60197  selfemployed_head_2015
   ren ER60460  selfemployed_spouse_2015

   ren ER66198  selfemployed_head_2017
   ren ER66473  selfemployed_spouse_2017

   ren ER72198  selfemployed_head_2019
   ren ER72475  selfemployed_spouse_2019  

 //RENAME WHO R LIVED WITH WHEN GROWING UP VARS
   ren ER11847 headlivedw_bothparents_1997
   ren ER15927 headlivedw_bothparents_1999
   ren ER19988 headlivedw_bothparents_2001
   ren ER23425 headlivedw_bothparents_2003
   ren ER27391 headlivedw_bothparents_2005
   ren ER40563 headlivedw_bothparents_2007

   ren ER46447 spouselivedw_bothparents_2009
   ren ER46541 headlivedw_bothparents_2009

   ren ER51808 spouselivedw_bothparents_2011
   ren ER51902 headlivedw_bothparents_2011

   ren ER57547 spouselivedw_bothparents_2013
   ren ER57657 headlivedw_bothparents_2013

   ren ER64669 spouselivedw_bothparents_2015
   ren ER64808 headlivedw_bothparents_2015

   ren ER70742 spouselivedw_bothparents_2017
   ren ER70880 headlivedw_bothparents_2017

   ren ER76750 spouselivedw_bothparents_2019
   ren ER76895 headlivedw_bothparents_2019

   //RENAME FOLLOW STATUS VARS
   ren ER33434 followstatus_1997
   ren ER33542 followstatus_1999
   ren ER33633 followstatus_2001
   ren ER33736 followstatus_2003
   ren ER33842 followstatus_2005
   ren ER33942 followstatus_2007
   ren ER34036 followstatus_2009
   ren ER34148 followstatus_2011
   ren ER34255 followstatus_2013
   ren ER34405 followstatus_2015
   ren ER34644 followstatus_2017
   ren ER34853 followstatus_2019

   //RENAME YEAR INDIVIDUAL WAS BORN
   ren ER30404 birthyear_1983   
   ren ER30434 birthyear_1984
   ren ER30468 birthyear_1985
   ren ER30503 birthyear_1986 
   ren ER30540 birthyear_1987 
   ren ER30575 birthyear_1988 
   ren ER30611 birthyear_1989 
   ren ER30647 birthyear_1990 
   ren ER30694 birthyear_1991
   ren ER30738 birthyear_1992 
   ren ER30811 birthyear_1993 
   ren ER33106 birthyear_1994 
   ren ER33206 birthyear_1995 
   ren ER33306 birthyear_1996

   ren ER33406 birthyear_1997
   ren ER33506 birthyear_1999
   ren ER33606 birthyear_2001
   ren ER33706 birthyear_2003
   ren ER33806 birthyear_2005
   ren ER33906 birthyear_2007
   ren ER34006 birthyear_2009
   ren ER34106 birthyear_2011
   ren ER34206 birthyear_2013
   ren ER34307 birthyear_2015
   ren ER34506 birthyear_2017
   ren ER34706 birthyear_2019

   //MONTH BORN
   ren ER30403 month_born_1983 
   ren ER30433 month_born_1984 
   ren ER30467 month_born_1985 
   ren ER30502 month_born_1986 
   ren ER30539 month_born_1987 
   ren ER30574 month_born_1988 
   ren ER30610 month_born_1989 
   ren ER30646 month_born_1990 
   ren ER30693 month_born_1991
   ren ER30737 month_born_1992 
   ren ER30810 month_born_1993 
   ren ER33105 month_born_1994 
   ren ER33205 month_born_1995 
   ren ER33305 month_born_1996 
   ren ER33405 month_born_1997 
   ren ER33505 month_born_1999
   ren ER33605 month_born_2001 
   ren ER33705 month_born_2003 
   ren ER33805 month_born_2005 
   ren ER33905 month_born_2007 
   ren ER34005 month_born_2009 
   ren ER34105 month_born_2011 
   ren ER34205 month_born_2013 
   ren ER34306 month_born_2015 
   ren ER34505 month_born_2017 

   //DATE OF INTERVIEW
   ren V99 intdate_1968_head 
   ren V553 intdate_1969_head 
   ren V1236 intdate_1970_head
   ren V1939 intdate_1971_head
   ren V2539 intdate_1972_head
   ren V3092 intdate_1973_head
   ren V3505 intdate_1974_head
   ren V3918 intdate_1975_head

   ren V4433 intdate_1976_head
   ren V4741 intdate_1976_spouse

   ren V5347 intdate_1977_head
   ren V5847 intdate_1978_head
   ren V6459 intdate_1979_head
   ren V7064 intdate_1980_head
   ren V7655 intdate_1981_head
   ren V8349 intdate_1982_head
   ren V8958 intdate_1983_head
   ren V10416 intdate_1984_head

   ren V11600 intdate_1985_head
   ren V11603 intdate_1985_spouse

   ren V13008 intdate_1986_head
   ren V14111 intdate_1987_head
   ren V15127 intdate_1988_head
   ren V16628 intdate_1989_head
   ren V18046 intdate_1990_head
   ren V19346 intdate_1991_head
   ren V20648 intdate_1992_head
   ren V22403 intdate_1993_head
   ren ER2005 intdate_1994_head
   ren ER5004 intdate_1995_head 
   ren ER7004 intdate_1996_head

   //RENAME "SPOUSE IN FU" VARIABLES
   ren ER54305 spouse_inFU2013
   ren ER61347 spouse_inFU2015

   //DROP OTHER UNNECESSARY VARS
   lookfor relat
   local relate "`r(varlist)'"

      foreach v of local relate {
          drop `v'
      }

   lookfor rele
   local release "`r(varlist)'"

      foreach v of local release {
          drop `v'
      }

   lookfor number 
   local number "`r(varlist)'"

      foreach v of local number {
         drop `v'
      }

   order son_id
   sort son_id
   compress 

   save ./RawData/extra_demographicvars, replace


